﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
/// Summary description for FormulaDAO
/// </summary>
public class FormulaDAO: dataAccess
{
	public FormulaDAO()
	{
		
	}
    public DataSet get()
    {
        string sql = "select td1.Name, td1.Code, td1.Description, td1.CreatedDate, td1.ModifiedDate,td3.Name as Animal from (select * from Formula) td1, Animal td3 where td1.AnimalID = td3.AnimalID";
        return getData(sql);
    }
    public DataSet getcbb()
    {

        string sql = "SELECT Name AS 'Animal',AnimalID FROM Animal";
        return getData(sql);
    }
}